<?php class Lab extends CI_Model {
	
            function __construct()
	    {
		parent::__construct();
	    }
            function listeClinic(){
		$sql = "SELECT * FROM clinique INNER JOIN compte ON compte.ID_COMPTE = clinique.ID_COMPTE WHERE compte.ETAT=1";			
		$Q = $this->db->query($sql);
		if ($Q->num_rows()>0){
			foreach ($Q->result_array() as $row){
				$data[]=$row;
			}
		}
		$Q->free_result();
		return $data;
	}
}
?>